Skip to main content

Importing Transactions

This guide provides detailed instructions for correctly populating the Excel template to ensure the successful upload of transactions into your online investor holdings management tool.

You can import Transactions by putting them into Excel Spreadsheet. You can download the template from the Import Page.

Transactions - Upload

Column Descriptions​

  1. Portfolio: The name of your investment portfolio.
  2. Broker: The name of your broker.
  3. Account: The name of your account.
  4. Date: The date of the transaction in the format YYYY-MM-DD.
  5. Holding: The ticker symbol or ISIN of the holding.
  6. Transaction: The type of transaction (e.g., Buy, Sell, Income, Split, Merge, Spin-Off).
  7. Units: The number of units/shares involved in the transaction.
  8. TC Value: The transaction currency value. Leave this blank if the value in user currency (PC Value) is provided.
  9. PC Value: The value in user currency. The system will translate this into the transaction currency.
  10. Reference: A detailed description of the transaction for reference.

Transaction Types and Examples​

  1. Buy Transaction

    • Example:
      • Date: 2023-03-23
      • Holding: AAPL.US
      • Transaction: Buy
      • Units: 1,000
      • PC Value: 129,620
    • Notes:
      • Buy Transaction of 1,000 shares of Apple listed on NASDAQ Stock Exchange (please note: for USA exchanges, "US" is used for all exchanges). Transaction value in user currency (PC) has been provided. The system will automatically translate the user currency into transaction currency (TC) using the exchange rate from the date of the transaction.

  2. Sell Transaction

    • Example:
      • Date: 2023-04-23
      • Holding: ASML.AS
      • Transaction: Sell
      • Units: 100
      • PC Value: 60,045
    • Notes:
      • Sale Transaction of 100 units/shares of ASML stock. The system will automatically calculate the realized gains from this transaction.

  3. Income Transaction

    • Example:
      • Date: 2023-04-23
      • Holding: ASML.AS
      • Transaction: Income
      • PC Value: 100
      • Notes:
        • Income Transaction: Dividends or any other income from the holding.

  4. Buy Transaction for Funds

    • Example:
      • Date: 2023-04-23
      • Holding: GB00BJL5BS14
      • Transaction: Buy
      • Units: 100
      • PC Value: 1,000
    • Notes:
      • Buy Transaction of fund: iShares Continental European Equity Index Fund (UK). This transaction uses the ISIN to indicate the holding.

  5. Split Transaction

    • Example:
      • Date: 2023-03-23
      • Holding: ASML.AS
      • Transaction: Split
      • Units: 1,800
      • Notes:
        • Split or Consolidation Transaction: 1,800 units indicate the new number of units. These should be made available by the broker. Based on this information, the application will post two transactions:
          1. Sale Transaction where all the stock is sold valued at cost.
          2. Buy Transaction where the stock units equal the number of units after split/consolidation and are valued at cost (cost is transferred to the new number of units).

  6. Merge Transaction

    • Example:
      • Date: 2022-02-14
      • Holding: XLNX.US
      • Transaction: Merge
    • Notes:
      • This and the next transaction represent a merger corporate action. The first transaction states which company/stock from the portfolio has been merged. In this case, this entry notifies that Xilinx (XLNX.US) has been merged. It serves as an initial record indicating that a company within your portfolio has undergone a merger action. The second transaction details the outcome of the merger for the portfolio. It specifies that Advanced Micro Devices (AMD.US) is the acquiring company. The portfolio holder receives a specific number of AMD shares in exchange for their Xilinx shares, based on the exchange ratio of 1.7234 AMD shares for each Xilinx share. The value of $123,080 represents the total value of the newly allocated AMD shares, as provided by the broker. This value should be approximately equal to or closely match the original investment value of the Xilinx shares, adjusted according to the merger terms and current market conditions.

  7. Spin-Off Transaction

    • Example:
      • Date: 2022-02-14
      • Holding: IBM.US
      • Transaction: Spin-Off
    • Notes:
      • This and the following transaction represent a spin-off corporate action. The first transaction identifies which company/stock from the portfolio has been spun off. In this case, this entry notifies that IBM has spun off Kyndryl (KD.US). It serves as an initial record indicating that a company within your portfolio has undergone a spin-off action. The second transaction details the outcome of the spin-off for the portfolio. It states the ticker of the new company (the spin-off). The value and number of shares received attributed to the newly received Kyndryl shares should be provided by the broker.

Additional Notes​

  • Ensure that the date format is consistent and correct (YYYY-MM-DD).
  • The units should reflect the number of shares or units exactly as per the transaction.
  • Provide clear and concise descriptions in the reference field to avoid confusion during data processing.
  • Validate that the PC Value is correctly calculated and reflects the value in your local currency.
  • Ensure that any corporate actions (e.g., mergers, spin-offs) are accurately detailed with all necessary information.